package com.sky.mapper;

import com.sky.dto.GoodsSalesDTO;
import com.sky.entity.User;
import com.sky.vo.SalesTop10ReportVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.time.LocalDate;
import java.time.LocalDateTime;
import java.util.List;

/**
 * @program: sky-take-out
 * @description:
 * @author: fmp
 * @create: 2023-04-09 15:10
 * @Version 1.0
 **/
@Mapper
public interface ReportMapper {
    //查询用户数据
    Double selectUserCount(@Param("localDateStart") LocalDateTime localDateStart, @Param("localDateend") LocalDateTime localDateend);
    //营业额查询
    Double turnoverReport(@Param("status") Integer status, @Param("localDateStart") LocalDateTime localDateStart, @Param("localDateend") LocalDateTime localDateend);
    //查询订单数
    Integer fordersReport(@Param("status") Integer status, @Param("localDateStart") LocalDateTime localDateStart,@Param("localDateend") LocalDateTime localDateend);

    List<GoodsSalesDTO> topReport(@Param("status") Integer status, @Param("localDateStart") LocalDateTime localDateStart, @Param("localDateend") LocalDateTime localDateend);
}
